{% extends 'base.html' %}
{% load staticfiles %}
{% block custom_css %}
    <link href="{% static 'css/common.css' %}" type="text/css" rel="stylesheet">
    <link href="{% static 'css/index.css' %}" type="text/css" rel="stylesheet">

    <link href="{% static 'css/bootstrap.min.css' %}" rel="stylesheet">
    <link href="{% static 'css/bootstrap-fileinput.css' %}" rel="stylesheet">
{% endblock %}
{% block content %}
    <div class="about_banner">
        <div class="container">
            <h2>Shortcodes</h2>
            <span class="breadcrumbs"><a href="index.html"><i class="fa fa-home home_1"></i></a> / <a href="news.html"
                                                                                                      class="home_desc">News</a> / <span>Shortcodes</span></span>
        </div>
    </div>
    <div class="about_top">
        <div class="container">

            <div class="col-md-9 column-15">
                <h4 class="m_11" style="text-align: center;">项目展示</h4>
                <div class="content-inner_1">
                    <div class="row">
                        <div class="col-md-3">
                            <h3>项目描述：</h3>
                        </div>
                    </div>
                    <p>&nbsp;</p>
                    <div class="row">
                        <div class="col-md-12">
                            <h5>完成项目素材中的SQL练习，并将编写的SQL文件和运行截图保存,打包后作为作业提交。<br>
                                设计一个学生成绩数据库，该库包含学生，老师，课程和成绩等信息并完成后面的练习(注意主外键关系)。<br>
                                学生：学号（SNO）、姓名(SNAME)、性别(SSEX)、生日(SBIRTHDAY )、所属班级(CLASS )<br>
                                课程：课程编号(CNO)、课程名(CNAME)、授课老师(TNO)<br>
                                成绩：学号(SNO)、课程编号(CNO)、得分(DEGREE)<br>
                                老师：教师编号(TNO)、教师姓名(TNAME)、性别(TSSEX)、生日(TBIRTHDAY)、职称(TITLE)、单位科室（DEPART）<br>
                                要求：<br>
                                一、每张表使用SQL语句插入至少10条数据。</h5>
                        </div>
                    </div>
                    <p>&nbsp;</p>
                    <p>&nbsp;</p>
                    <form class="contact">
                        <div class="row">
                            <div class="col-md-3">
                                <h3>项目截图：</h3>
                            </div>
                            <div class="col-md-6">
                                <img src="{{ MEDIA_URL }}{{ program_result.image }}" alt=""
                                     style="width: 400px;height: 400px;">
                            </div>
                            <div class="clearfix"></div>
                        </div>
                        <p>&nbsp;</p>
                        <p>&nbsp;</p>
                        <textarea value="Message"
                                  style="color: #3c3c3c;" id="learned"
                                  readonly="readonly">{{ program_result.learned }}
                            </textarea>
                        <p>&nbsp;</p>
                        <p>&nbsp;</p>
                        <div class="row">
                            <div class="col-md-3">
                                <h3>项目文件：</h3>
                            </div>
                            <div class="col-md-6">
                                附件：<a href="{{ MEDIA_URL }}{{ program_result.url }}"
                                      target="_blank">{{ program_result.url }}</a>
                            </div>
                            <div class="clearfix"></div>
                        </div>
                        {% csrf_token %}
                    </form>
                </div>
            </div>
            <div class="col-md-3 column-1 column-13">
                <i class="fa fa-envelope-o envelop"></i>
                <address class="address">
                    <p>讲师：{{ program_result.user }}</p>
                    <dl>
                        <dt></dt>
                        <dd>Freephone :&nbsp;<span> +1 800 254 2478</span></dd>
                        <dd>Telephone :&nbsp;<span> +1 800 547 5478</span></dd>
                        <dd>FAX :&nbsp;<span>+1 800 658 5784</span></dd>
                        <dd>提交项目后获得项目评分</dd>

                    </dl>
                </address>

            </div>
            <div class="col-md-3 column-1 column-13">
                <address class="address">
                    <h3>课前必学</h3>
                    {% for course in program_result.course.all %}
                        <hr>
                        <img src="{{ MEDIA_URL }}{{ course.image }}">
                        <p></p>
                        <p></p>
                        <h4>{{ course.name }}</h4>
                        <p></p>
                        <div style="padding-left: 15px;padding-right:15px;">
                            <span style="color: white;">{{ course.detail|slice:"70" }}...</span>
                            <p></p>
                            <div >
                                <h4 style="float: left;">{{ course.get_degree_display }}</h4>
                                <i class="fa fa-user fa-lg"
                                   style="color: white">&nbsp;&nbsp;&nbsp;&nbsp;{{ course.students }}</i>
{#                                <span class="post-meta-comments fa-lg"><i class="fa fa-comment"></i>1</span>#}
                            </div>

                        </div>
                        <p></p>

                    {% endfor %}
                </address>

            </div>
        </div>
        <div class="clearfix"></div>
    </div>
{% endblock %}

{% block custom_js %}
    <script src="{% static 'js/imgUp.js' %}"></script>

    <script src="{% static 'js/bootstrap-fileinput.js' %}"></script>

{% endblock %}




